INSERT INTO [EtownManage].[dbo].[GroupAccount]([name],[description],[create_date])
VALUES ('admin','quanli',2012/07/15)
GO
INSERT INTO [EtownManage].[dbo].[GroupAccount]([name],[description],[create_date])
VALUES ('Customer','customer',2012/07/15)
GO


INSERT INTO [EtownManage].[dbo].[Account]([loginName],[password],[create_date])
VALUES ('admin','admin',2012/07/15)
GO


INSERT INTO [EtownManage].[dbo].[Block]([blockName],[description],[create_date])
VALUES ('block A','first block',2012/7/15)
GO

INSERT INTO [EtownManage].[dbo].[Floor]([floorName],[blockId],[description],[create_date])
VALUES ('floor 1',1,'first floor',2012/7/15)
GO

INSERT INTO [EtownManage].[dbo].[Unit]([unitName],[floorId],[blockId],[cost],[status],[description],[create_date])
VALUES ('unit a101',1,1,25000,1,'first unit',2012/7/15)
GO

